Skip Headers

Oracle® Database Backup and Recovery Advanced User's Guide 10g Release 2 (10.2) Part Number B14191-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# 19 Advanced User-Managed Recovery Scenarios

This chapter describes several common media failure scenarios. It shows how to recover from each failure when using a user-managed backup and recovery strategy, that is, a strategy that does not depend upon Recovery Manager. This chapter includes the following topics:

- Recovering After the Loss of Datafiles: Scenarios

- Recovering Through an Added Datafile with a Backup Control File: Scenario

- Re-Creating Datafiles When Backups Are Unavailable: Scenario

- Recovering Through RESETLOGS with Created Control File: Scenario

- Recovering NOLOGGING Tables and Indexes: Scenario

- Recovering Read-Only Tablespaces with a Backup Control File: Scenario

- Media Recovery of Transportable Tablespaces: Scenario

- Recovering After the Loss of Online Redo Log Files: Scenarios

- Recovering After the Loss of Archived Redo Log Files: Scenario

- Recovering from a Dropped Table: Scenario

- Performing Media Recovery in a Distributed Environment: Scenario

- Dropping a Database with SQL*Plus

This chapter was last modified November 10, 2005 4:48 pm